ALTER TABLE Properties
DROP COLUMN Area 
GO
ALTER TABLE Properties
DROP COLUMN Price 
GO
ALTER TABLE Properties
DROP COLUMN Luxury 
GO
ALTER TABLE Properties
DROP COLUMN [Transaction] 
GO
ALTER TABLE Properties
DROP COLUMN [Ownership]
GO
ALTER TABLE Properties
ADD AreaSqMt VARCHAR(50)
GO
ALTER TABLE Properties
ADD YearBuilt VARCHAR(10)
GO